LOAD DATA 
 INFILE unidades_est.dat
 TRUNCATE
 CONTINUEIF NEXT(1:1) = '#'
 INTO TABLE UNIDADES_EST
 FIELDS TERMINATED BY '|'
 TRAILING NULLCOLS (
   OBJECTID,
   id_unidad,
   descripcio 	NULLIF descripcio = BLANKS,
   Perfil_tip 	NULLIF Perfil_tip = BLANKS,
   Estrato_Ti 	NULLIF Estrato_Ti = BLANKS,
   id_humedal,
   Shape_Leng,
   Shape_Area,
   GEO COLUMN OBJECT 
   (
     SDO_GTYPE       INTEGER EXTERNAL, 
     SDO_ELEM_INFO   VARRAY TERMINATED BY '|/' 
       (X            FLOAT EXTERNAL), 
     SDO_ORDINATES   VARRAY TERMINATED BY '|/' 
       (X            FLOAT EXTERNAL) 
   )
)
